// See the DataAccess setup code on the DataAccess class page.

// Executes a DB script file.
private static void ExecuteScript(DataAccess dataAccess)
{
    // Create a DB Script file.
    StringBuilder builder = new StringBuilder(64);
    builder.AppendLine("insert into TestTable values('Name1');");
    builder.AppendLine("go");
    builder.AppendLine("delete from TestTable where Name = 'Name1';");
    builder.AppendLine("go");
    string scriptText = builder.ToString();
    File.WriteAllText("TestScript.sql", scriptText);

    dataAccess.ExecuteScript("TestScript.sql");
}